🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-18 🟡

🔹 Automate Lead Generation into Google Sheets via Claude AI
👤 Client: 🇺🇾 Uruguay Member since 2023-10-06
💰 Price: ****
🚩 Problem: Need an automated system to research and populate potential buyer contacts for target companies in a Google Sheet.
📦 Existing: Google Sheet with company names, Claude AI API access.

Specifications:

[Target] Research and gather contact information (full name, LinkedIn URL) and personalized outreach messages for meat/protein procurement roles at specified companies.
[Method] Use Claude AI API to perform web searches and extract relevant data. Integrate with Google Sheets via Apps Script or direct API calls.
[UI/UX] No user interface required; automation runs in the background based on triggers (manual or scheduled).
[Stack] Anthropic Claude API, Google Sheets API, JavaScript for Apps Script integration.
[Security] Ensure data privacy and security by handling sensitive information securely. Use OAuth 2.0 for API access.
[Format] Output structured JSON objects containing contact details and outreach messages to be written into specific rows of the Google Sheet.

Workflow:

1. Define the structure of the output JSON object with fields: full name, LinkedIn URL, first touch message, follow-up message, final follow-up message.
2. Set up a trigger in Apps Script or use Make.com/Zapier to run the script on demand or at scheduled intervals.
3. Use Claude API within the script to search for and extract relevant contact information and personalized messages.
4. Write the extracted data into the corresponding rows of the Google Sheet.